package com.booksystem.campuslibrarymanagementsystem.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.booksystem.campuslibrarymanagementsystem.entity.SystemTable;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface SystemTableMapper extends BaseMapper<SystemTable> {
    @Select("SELECT * FROM system_table\n" +
            "ORDER BY announcementid DESC\n" +
            "LIMIT 1;")
    SystemTable findLatestAnnouncement();
}
